
# 1. 按列生成过于简单的公式
def simple(models):
    for m in models:
        for i in range(25):
            print(f"='[CycleFusion.xlsx]{m}'!$D${2+i}")

# 2. 按sheet生成公式
def concatedCMD(models,DEF):
    for i in range(24):
        for m in models:
            # print(f"='[CycleFusion.xlsx]{m}'!${DEF}${2+i}",end="\t")
            print(f"='[CycleFusion-3.xlsx]{m}'!${DEF}${2+i}",end="\t")  #='[CycleFusion-3.xlsx]CycleFusion'!$D$2
        print()


if __name__ == '__main__':
     # models = ["CycleFusion", "DDcGAN", "DenseFuse", "FusionGAN", "IFCNN-MEAN", "NestFuse_Avg", "SeAFusion",
     #          "ADF", "CSR", "FPDE", "IFEVIP", "Bayes","VSMWLS"]

     paired_models = ["CycleFusion", "DDcGAN", "DenseFuse", "FusionGAN", "IFCNN-MEAN", "NestFuse_Avg", "SeAFusion",
              "ADF", "CSR", "FPDE", "IFEVIP", "IVIFBayes","VSMWLS"]


     # simple(models)

     # 生成表格的公式
     concatedCMD(paired_models,"S")

